
#importing Required library 
import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
%matplotlib inline


#importing plotly Library
from plotly.offline import iplot
import plotly as py
import plotly.tools as tls
import cufflinks as cf
py.offline.init_notebook_mode(connected=True) #Turning on notebook mode 
cf.go_offline()


df=pd.read_csv(r"C:\Users\shri\Downloads\CAR DETAILS FROM CAR DEKHO.csv") #dataset


df.shape

(4340, 8)


df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 4340 entries, 0 to 4339
Data columns (total 8 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   name           4340 non-null   object
 1   year           4340 non-null   int64 
 2   selling_price  4340 non-null   int64 
 3   km_driven      4340 non-null   int64 
 4   fuel           4340 non-null   object
 5   seller_type    4340 non-null   object
 6   transmission   4340 non-null   object
 7   owner          4340 non-null   object
dtypes: int64(3), object(5)
memory usage: 271.4+ KB


df.describe()


df.head()


df.tail()


df.isnull().sum()

name             0
year             0
selling_price    0
km_driven        0
fuel             0
seller_type      0
transmission     0
owner            0
dtype: int64


df['Age'] = 2021 - df['year']
df.drop('year',axis=1,inplace = True)


df.head()


pd.set_option("display.max_rows", None, "display.max_columns",None)
df


cat_cols = ['fuel','seller_type','transmission','owner']
i=0
while i < 4:
    fig = plt.figure(figsize=[20,5])   
    
    plt.subplot(1,2,1)
    sns.countplot(x=cat_cols[i], data=df)
    i += 1  
    
    plt.subplot(1,2,2)
    sns.countplot(x=cat_cols[i], data=df)
    i += 1
    
    plt.show()


df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 4340 entries, 0 to 4339
Data columns (total 8 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   name           4340 non-null   object
 1   selling_price  4340 non-null   int64 
 2   km_driven      4340 non-null   int64 
 3   fuel           4340 non-null   object
 4   seller_type    4340 non-null   object
 5   transmission   4340 non-null   object
 6   owner          4340 non-null   object
 7   Age            4340 non-null   int64 
dtypes: int64(3), object(5)
memory usage: 271.4+ KB


num_cols = ['selling_price','km_driven','Age','selling_price']
i=0
while i < 4:
    fig = plt.figure(figsize=[13,3])
    
    plt.subplot(1,2,1)
    sns.boxplot(x=num_cols[i], data=df)
    i += 1
    
    
    plt.subplot(1,2,2)
    sns.boxplot(x=num_cols[i], data=df)
    i += 1
    
    plt.show()


df['selling_price'].quantile(0.99)

3200000.0


df[df['selling_price'] > df['selling_price'].quantile(0.99)].sort_values(by="selling_price",ascending=False)


df[df['km_driven'] > df['km_driven'].quantile(0.99)].sort_values(by="km_driven",ascending=False)


df[df['Age'] > df['Age'].quantile(0.99)].sort_values(by="Age",ascending=False)


df.sort_values(by="selling_price")


df["name"].value_counts().sort_values(ascending=False).head(10).iplot(kind="bar")


fuel=df.groupby(by="fuel")


fuel.selling_price.mean().sort_values(ascending=False).iplot(kind="bar")


sns.heatmap(df.corr(), annot=True, cmap="RdBu")
plt.show()


owner=df.groupby(by="owner")


owner.selling_price.mean().sort_values(ascending=False).iplot(kind="bar")


sns.pairplot(df)

<seaborn.axisgrid.PairGrid at 0x1af2fc90430>


df.shape

(4340, 8)


car_names=df["name"].unique()


df["name"].nunique()

1491


pd.DataFrame(car_names)


df['brand'] = df['name'].str.split(' ').str[0]

df


df.brand.unique()

array(['Maruti', 'Hyundai', 'Datsun', 'Honda', 'Tata', 'Chevrolet',
       'Toyota', 'Jaguar', 'Mercedes-Benz', 'Audi', 'Skoda', 'Jeep',
       'BMW', 'Mahindra', 'Ford', 'Nissan', 'Renault', 'Fiat',
       'Volkswagen', 'Volvo', 'Mitsubishi', 'Land', 'Daewoo', 'MG',
       'Force', 'Isuzu', 'OpelCorsa', 'Ambassador', 'Kia'], dtype=object)


df.brand.nunique()

29


df.brand.value_counts().sort_values(ascending=False).iplot(kind="bar")


df.brand.value_counts().sort_values().head(15).iplot(kind="bar")


df[df.selling_price>2500000].sort_values(by="selling_price").brand.unique()

array(['Jaguar', 'Audi', 'Toyota', 'BMW', 'Ford', 'Mahindra', 'Land',
       'Mercedes-Benz', 'Volvo'], dtype=object)


top_brands=['Jaguar', 'Audi', 'BMW','Land','Mercedes-Benz', 'Volvo']


df[df["brand"] == 'Audi']


tdf=df.loc[df['brand'].isin(top_brands)]


tdf.shape

(149, 9)


df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 4340 entries, 0 to 4339
Data columns (total 9 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   name           4340 non-null   object
 1   selling_price  4340 non-null   int64 
 2   km_driven      4340 non-null   int64 
 3   fuel           4340 non-null   object
 4   seller_type    4340 non-null   object
 5   transmission   4340 non-null   object
 6   owner          4340 non-null   object
 7   Age            4340 non-null   int64 
 8   brand          4340 non-null   object
dtypes: int64(3), object(6)
memory usage: 305.3+ KB


sns.relplot(x=df.selling_price,y=df.km_driven,hue=df.brand)

<seaborn.axisgrid.FacetGrid at 0x1af34a43d30>


sns.relplot(x=tdf.selling_price,y=tdf.km_driven,hue=tdf.brand)

<seaborn.axisgrid.FacetGrid at 0x1af2fc721c0>


tdf.brand.value_counts().sort_values(ascending=False).iplot(kind="bar")


topcars=tdf.groupby("brand")


topcars.mean().sort_values(by="selling_price").iplot(kind="bar")


topcars.mean().sort_values(by="selling_price").sort_values(by="selling_price")


tdf.transmission.value_counts()

Automatic    147
Manual         2
Name: transmission, dtype: int64


tdf.fuel.value_counts().plot.pie(fontsize = 18, autopct = '%.2f')

<AxesSubplot:ylabel='fuel'>


tdf.seller_type.value_counts().plot.pie(fontsize = 18, autopct = '%.2f')

<AxesSubplot:ylabel='seller_type'>


tdf.name.value_counts().sort_values(ascending=False).head()

Audi A6 2.0 TDI Premium Plus                13
Audi A4 3.0 TDI Quattro                     12
Mercedes-Benz C-Class Progressive C 220d    11
BMW X5 xDrive 30d xLine                     11
BMW X1 sDrive 20d xLine                      5
Name: name, dtype: int64


ndf=df.loc[~df['brand'].isin(top_brands)]

ndf


ndf.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 4191 entries, 0 to 4339
Data columns (total 9 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   name           4191 non-null   object
 1   selling_price  4191 non-null   int64 
 2   km_driven      4191 non-null   int64 
 3   fuel           4191 non-null   object
 4   seller_type    4191 non-null   object
 5   transmission   4191 non-null   object
 6   owner          4191 non-null   object
 7   Age            4191 non-null   int64 
 8   brand          4191 non-null   object
dtypes: int64(3), object(6)
memory usage: 327.4+ KB


print("Share of Normal Segment Cars in %: ") 
print(len(ndf)/len(df)*100)
print("-------------------------------------")
print("Share of premium Segment Cars in % : ") 
print(len(tdf)/len(df)*100)

Share of Normal Segment Cars in %: 
96.5668202764977
-------------------------------------
Share of premium Segment Cars in % : 
3.433179723502304


sns.relplot(x=ndf.selling_price,y=ndf.km_driven,hue=ndf.brand)

<seaborn.axisgrid.FacetGrid at 0x1af36e44910>


ndf.brand.value_counts().sort_values(ascending=False).iplot(kind="bar")


normalcars=ndf.groupby("brand")


normalcars.mean().sort_values(by="selling_price",ascending=False).iplot(kind="bar")


normalcars.mean().sort_values(by="selling_price").sort_values(by="selling_price")


ndf.transmission.value_counts()

Manual       3890
Automatic     301
Name: transmission, dtype: int64


ndf.seller_type.value_counts().plot.pie(fontsize = 18, autopct = '%.2f')

<AxesSubplot:ylabel='seller_type'>


ndf.fuel.value_counts()

Petrol      2104
Diesel      2023
CNG           40
LPG           23
Electric       1
Name: fuel, dtype: int64


ndf.fuel.value_counts().plot.pie(fontsize = 10, autopct = '%.2f')

<AxesSubplot:ylabel='fuel'>


ndf.fuel.value_counts().plot.bar()

<AxesSubplot:>

	year	selling_price	km_driven
count	4340.000000	4.340000e+03	4340.000000
mean	2013.090783	5.041273e+05	66215.777419
std	4.215344	5.785487e+05	46644.102194
min	1992.000000	2.000000e+04	1.000000
25%	2011.000000	2.087498e+05	35000.000000
50%	2014.000000	3.500000e+05	60000.000000
75%	2016.000000	6.000000e+05	90000.000000
max	2020.000000	8.900000e+06	806599.000000

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner
0	Maruti 800 AC	2007	60000	70000	Petrol	Individual	Manual	First Owner
1	Maruti Wagon R LXI Minor	2007	135000	50000	Petrol	Individual	Manual	First Owner
2	Hyundai Verna 1.6 SX	2012	600000	100000	Diesel	Individual	Manual	First Owner
3	Datsun RediGO T Option	2017	250000	46000	Petrol	Individual	Manual	First Owner
4	Honda Amaze VX i-DTEC	2014	450000	141000	Diesel	Individual	Manual	Second Owner

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner
4335	Hyundai i20 Magna 1.4 CRDi (Diesel)	2014	409999	80000	Diesel	Individual	Manual	Second Owner
4336	Hyundai i20 Magna 1.4 CRDi	2014	409999	80000	Diesel	Individual	Manual	Second Owner
4337	Maruti 800 AC BSIII	2009	110000	83000	Petrol	Individual	Manual	Second Owner
4338	Hyundai Creta 1.6 CRDi SX Option	2016	865000	90000	Diesel	Individual	Manual	First Owner
4339	Renault KWID RXT	2016	225000	40000	Petrol	Individual	Manual	First Owner

	name	selling_price	km_driven	fuel	seller_type	transmission	owner	Age
0	Maruti 800 AC	60000	70000	Petrol	Individual	Manual	First Owner	14
1	Maruti Wagon R LXI Minor	135000	50000	Petrol	Individual	Manual	First Owner	14
2	Hyundai Verna 1.6 SX	600000	100000	Diesel	Individual	Manual	First Owner	9
3	Datsun RediGO T Option	250000	46000	Petrol	Individual	Manual	First Owner	4
4	Honda Amaze VX i-DTEC	450000	141000	Diesel	Individual	Manual	Second Owner	7

	name	selling_price	km_driven	fuel	seller_type	transmission	owner	Age
3872	Audi RS7 2015-2019 Sportback Performance	8900000	13000	Petrol	Dealer	Automatic	First Owner	5
89	Mercedes-Benz S-Class S 350d Connoisseurs Edition	8150000	6500	Diesel	Dealer	Automatic	First Owner	4
3969	Mercedes-Benz GLS 2016-2020 350d 4MATIC	5500000	77350	Diesel	Dealer	Automatic	First Owner	5
612	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
1836	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
2258	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
1023	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
2739	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
919	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
2239	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
900	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
593	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
574	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
555	BMW X5 xDrive 30d xLine	4950000	30000	Diesel	Dealer	Automatic	First Owner	2
3453	BMW 5 Series 520d Luxury Line	4800000	9422	Diesel	Individual	Automatic	First Owner	3
3883	BMW 5 Series 520d Luxury Line	4800000	12999	Diesel	Dealer	Automatic	First Owner	2
963	Audi A5 Sportback	4700000	1500	Diesel	Individual	Automatic	First Owner	1
101	Mercedes-Benz E-Class Exclusive E 200 BSIV	4500000	9800	Petrol	Dealer	Automatic	First Owner	3
2580	Mercedes-Benz E-Class Exclusive E 200 BSIV	4500000	9800	Petrol	Dealer	Automatic	First Owner	3
4047	Volvo XC 90 D5 Inscription BSIV	4500000	80000	Diesel	Individual	Automatic	First Owner	4
539	Mercedes-Benz GL-Class 350 CDI Blue Efficiency	4400000	100000	Diesel	Individual	Automatic	Second Owner	7
2178	Mercedes-Benz GL-Class 350 CDI Blue Efficiency	4400000	100000	Diesel	Individual	Automatic	Second Owner	7
3875	Land Rover Range Rover 4.4 Diesel LWB Vogue SE	4200000	100000	Diesel	Dealer	Automatic	First Owner	11
731	Land Rover Discovery Sport TD4 HSE 7S	4000000	68000	Diesel	Individual	Automatic	First Owner	3
968	BMW 7 Series Signature 730Ld	4000000	47000	Diesel	Individual	Automatic	First Owner	7
988	Land Rover Discovery S 2.0 SD4	4000000	68000	Petrol	Individual	Automatic	First Owner	3
2295	Audi Q5 3.0 TDI Quattro Technology	3899000	22000	Diesel	Dealer	Automatic	First Owner	3
4304	Audi Q5 3.0 TDI Quattro Technology	3899000	22000	Diesel	Dealer	Automatic	First Owner	3
2237	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
2256	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
1834	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
2737	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
1021	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
917	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
898	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
610	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
591	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
572	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
553	Mercedes-Benz C-Class Progressive C 220d	3800000	10000	Diesel	Dealer	Automatic	First Owner	3
1705	Audi Q5 2.0 TDI	3500000	35000	Diesel	Individual	Automatic	First Owner	6
1088	Land Rover Discovery Sport SD4 HSE Luxury	3500000	53000	Diesel	Dealer	Automatic	First Owner	5
1479	Audi A4 35 TDI Premium Plus	3256000	17000	Diesel	Dealer	Automatic	First Owner	2

EDA of Data From CarDekho.com¶

Outliers in selling price¶

Analysis of premium segment cars¶

Analysis of Normal Segment cars¶

	name	selling_price	km_driven	fuel	seller_type	transmission	owner	Age
1243	Maruti Swift VXI BSIII	250000	806599	Petrol	Dealer	Manual	First Owner	12
4184	Maruti SX4 S Cross DDiS 320 Delta	665000	560000	Diesel	Dealer	Manual	First Owner	5
525	Maruti SX4 S Cross DDiS 320 Delta	665000	560000	Diesel	Dealer	Manual	First Owner	5
3679	Toyota Innova 2.5 G (Diesel) 7 Seater BS IV	400000	400000	Diesel	Individual	Manual	Third Owner	15
69	Chevrolet Tavera Neo LS B3 - 7(C) seats BSIII	280000	350000	Diesel	Individual	Manual	Second Owner	11
2394	Toyota Innova 2.5 V Diesel 8-seater	350000	350000	Diesel	Individual	Manual	First Owner	12
3718	Toyota Innova 2.5 GX 8 STR BSIV	420000	347089	Diesel	Dealer	Manual	First Owner	12
1674	Volkswagen Jetta 2.0 TDI Comfortline	350000	312000	Diesel	Individual	Manual	Third Owner	10
1101	Tata Indica DLS	85000	300000	Diesel	Individual	Manual	Second Owner	15
3994	Tata Indica GLS BS IV	75000	300000	Petrol	Individual	Manual	Third Owner	11
3898	Tata Indica GLS BS IV	90000	300000	Petrol	Individual	Manual	Third Owner	11
1659	Toyota Innova 2.5 G (Diesel) 8 Seater BS IV	229999	300000	Diesel	Individual	Manual	First Owner	15
3646	Toyota Innova 2.5 G (Diesel) 8 Seater BS IV	229999	300000	Diesel	Individual	Manual	First Owner	15
2964	Maruti Swift VDI	225000	296823	Diesel	Individual	Manual	First Owner	9
3675	Mahindra Xylo E9	300000	295000	Diesel	Individual	Manual	First Owner	9
3979	Mahindra Verito 1.5 D2 BSIII	150000	280000	Diesel	Individual	Manual	First Owner	10
2961	Mahindra Scorpio VLS 2.2 mHawk	300000	270000	Diesel	Individual	Manual	Third Owner	13
2401	Toyota Innova 2.5 E Diesel MS 7-seater	665000	267000	Diesel	Individual	Manual	Second Owner	10
3171	Maruti Swift Dzire VDI	450000	260000	Diesel	Individual	Manual	Second Owner	7
4208	Toyota Qualis FS B3	150000	256000	Diesel	Dealer	Manual	First Owner	20
2402	Mahindra Scorpio 2.6 CRDe	175000	250000	Diesel	Individual	Manual	Second Owner	16
2760	Tata New Safari DICOR 2.2 EX 4x2	300000	250000	Diesel	Individual	Manual	Second Owner	11
4088	Maruti 800 AC	120000	250000	Petrol	Individual	Manual	Second Owner	12
3981	Toyota Innova 2.5 VX (Diesel) 8 Seater	1030000	250000	Diesel	Individual	Manual	Second Owner	7
3461	Toyota Innova 2.5 EV Diesel PS 7 Seater BSIII	300000	250000	Diesel	Individual	Manual	First Owner	9
2278	Hyundai Accent CRDi	170000	245244	Diesel	Individual	Manual	Fourth & Above Owner	15
1668	Toyota Innova 2.5 GX (Diesel) 7 Seater	650000	244000	Diesel	Individual	Manual	First Owner	7
3470	Mahindra Xylo Celebration Edition BSIV	200000	240000	Diesel	Individual	Manual	Third Owner	11
3572	Mahindra Scorpio VLX 2WD AIRBAG BSIV	600000	238000	Diesel	Individual	Manual	First Owner	7
3611	Hyundai Verna 1.6 SX	434999	235000	Diesel	Individual	Manual	Second Owner	9
1414	Skoda Superb Elegance 2.0 TDI CR AT	450000	235000	Diesel	Individual	Automatic	First Owner	10
1253	Toyota Corolla Altis D-4D J	715000	234000	Diesel	Individual	Manual	First Owner	7
4231	Toyota Innova 2.5 G (Diesel) 8 Seater BS IV	800000	230000	Diesel	Individual	Manual	First Owner	10
1923	Mahindra Bolero SLE BSIII	185000	230000	Diesel	Individual	Manual	Second Owner	14
197	Mahindra Xylo E4	229999	230000	Diesel	Individual	Manual	Third Owner	12
70	Toyota Corolla Altis Diesel D4DG	350000	230000	Diesel	Individual	Manual	First Owner	10
3531	Ford Endeavour 2.5L 4X2	500000	224642	Diesel	Dealer	Manual	Second Owner	10
1426	Mahindra Scorpio VLX AT 2WD BSIII	225000	223660	Diesel	Individual	Automatic	Third Owner	17
1116	Toyota Innova 2.5 V Diesel 7-seater	200000	223000	Diesel	Individual	Manual	First Owner	16
2955	Toyota Innova 2.5 G4 Diesel 7-seater	440000	223000	Diesel	Individual	Manual	Fourth & Above Owner	14
3541	Mahindra Scorpio 2.6 CRDe	180000	222435	Diesel	Individual	Manual	Second Owner	15
3734	Mahindra XUV500 W8 2WD	550000	222252	Diesel	Individual	Manual	First Owner	8
2855	Mahindra Scorpio 2.6 CRDe	229999	221000	Diesel	Individual	Manual	Third Owner	16

	name	selling_price	km_driven	fuel	seller_type	transmission	owner	Age
3334	Maruti 800 AC BSII	50000	100000	Petrol	Individual	Manual	Fourth & Above Owner	29
631	Maruti Gypsy E MG410W ST	95000	100000	Petrol	Individual	Manual	Second Owner	26
61	Mahindra Jeep CL 500 MDI	250000	35000	Diesel	Individual	Manual	Second Owner	25
2972	Mahindra Jeep MM 540	200000	60000	Diesel	Individual	Manual	First Owner	25
3550	Maruti Esteem AX	79000	70000	Petrol	Individual	Automatic	First Owner	24
3661	Maruti 800 Std	50000	80000	Petrol	Individual	Manual	Second Owner	24
1669	Mahindra Jeep CL 500 MDI	150000	120000	Diesel	Individual	Manual	Third Owner	24
2044	Mercedes-Benz E-Class 230	1000000	35000	Petrol	Individual	Automatic	Second Owner	23
3371	Honda City 1.3 EXI	85000	120000	Petrol	Individual	Manual	Second Owner	23
3237	Maruti 800 Std	40000	40000	Petrol	Individual	Manual	Fourth & Above Owner	23
2908	Maruti 800 Std	55000	80000	Petrol	Individual	Manual	Fourth & Above Owner	23
3621	Maruti Zen LX	42000	70000	Petrol	Individual	Manual	Third Owner	23
137	Maruti 800 Std	40000	40000	Petrol	Individual	Manual	Fourth & Above Owner	23
2342	Maruti Omni 5 Str STD	65000	60000	Petrol	Dealer	Manual	Third Owner	23
2337	Mercedes-Benz E-Class 230	1000000	35000	Petrol	Individual	Automatic	Second Owner	23
1943	Maruti Zen LXI	69000	70000	Petrol	Individual	Manual	Second Owner	23
3532	Maruti Zen LXI	80000	120000	Petrol	Individual	Manual	Second Owner	23
3622	Maruti Zen LX	42000	70000	Petrol	Individual	Manual	Third Owner	23
1699	Maruti Omni 5 Str STD LPG	50000	35000	LPG	Individual	Manual	Second Owner	23
2097	Hyundai Accent GLE 1	60000	90000	Petrol	Individual	Manual	Fourth & Above Owner	22
1579	Mahindra Jeep Classic	170000	2020	Diesel	Individual	Manual	Second Owner	22
3849	Maruti Zen LX	70000	70000	Petrol	Individual	Manual	Fourth & Above Owner	22
3856	Maruti 800 AC	50000	100000	Petrol	Individual	Manual	Second Owner	22
2777	Maruti Zen LX	75000	70000	Petrol	Individual	Manual	First Owner	22
2904	Maruti Zen LX	70000	70000	Petrol	Individual	Manual	Fourth & Above Owner	22
1126	Maruti Esteem VX	60000	35000	Petrol	Individual	Manual	Second Owner	22
850	Maruti Zen LXI	85000	70000	Petrol	Individual	Manual	Second Owner	22
391	Hyundai Santro GLS I - Euro I	50000	120000	Petrol	Individual	Manual	Second Owner	22
3396	Maruti 800 Std	45000	50000	Petrol	Individual	Manual	Third Owner	22
3889	Maruti Alto LX	61000	90000	Petrol	Individual	Manual	Second Owner	21
3984	Maruti Zen LX	85000	80000	Petrol	Individual	Manual	Second Owner	21
2495	Ford Ikon 1.4 ZXi	22000	42743	Petrol	Dealer	Manual	Third Owner	21
2635	Maruti Zen VXI	100000	120000	Petrol	Individual	Manual	First Owner	21
2560	Maruti Wagon R VXI	105000	80000	Petrol	Individual	Manual	First Owner	21
1927	Maruti Zen LX	60000	50000	Petrol	Individual	Manual	First Owner	21
1598	Maruti Wagon R VX	50000	88500	Petrol	Individual	Manual	Fourth & Above Owner	21
1404	Maruti 800 DX	50000	60000	Petrol	Individual	Manual	First Owner	21
1397	Mahindra Jeep MM 775 XDB	155000	50000	Diesel	Individual	Manual	Second Owner	21
1184	Maruti Gypsy King Hard Top	165000	60000	Petrol	Individual	Manual	Fourth & Above Owner	21
372	Maruti 800 AC	60000	40000	Petrol	Individual	Manual	Third Owner	21
4325	Maruti Alto LXi	65000	90000	Petrol	Individual	Manual	Second Owner	21

	name	selling_price	km_driven	fuel	seller_type	transmission	owner	Age	brand
32	Audi Q5 2.0 TDI	1190000	175900	Diesel	Dealer	Automatic	First Owner	10	Audi
35	Audi A6 2.0 TDI Design Edition	1735000	50000	Diesel	Dealer	Automatic	First Owner	8	Audi
44	Audi Q7 35 TDI Quattro Premium	1250000	78000	Diesel	Dealer	Automatic	Third Owner	12	Audi
94	Audi A6 2.0 TDI Premium Plus	1470000	34000	Diesel	Dealer	Automatic	Second Owner	7	Audi
96	Audi A8 4.2 TDI	2800000	49000	Diesel	Dealer	Automatic	First Owner	8	Audi
99	Audi A4 2.0 TDI 177 Bhp Premium Plus	1150000	53000	Diesel	Dealer	Automatic	First Owner	8	Audi
431	Audi Q5 2.0 TDI	1350000	90000	Diesel	Individual	Automatic	Second Owner	9	Audi
554	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
566	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
573	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
585	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
592	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
604	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
611	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
623	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
721	Audi A4 New 2.0 TDI Multitronic	1549000	42215	Diesel	Dealer	Automatic	First Owner	7	Audi
899	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
911	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
918	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
930	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
959	Audi Q3 35 TDI Quattro Technology	2700000	25000	Diesel	Individual	Automatic	First Owner	3	Audi
963	Audi A5 Sportback	4700000	1500	Diesel	Individual	Automatic	First Owner	1	Audi
1033	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
1065	Audi A4 30 TFSI Technology	3100000	22000	Petrol	Individual	Automatic	First Owner	3	Audi
1077	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
1078	Audi Q3 2.0 TDI Quattro Premium Plus	1750000	127643	Diesel	Dealer	Automatic	First Owner	6	Audi
1080	Audi A6 2.0 TDI Design Edition	1750000	102354	Diesel	Dealer	Automatic	First Owner	7	Audi
1081	Audi Q5 2.0 TFSI Quattro Premium Plus	1850000	62237	Petrol	Dealer	Automatic	First Owner	7	Audi
1410	Audi A4 35 TDI Premium	2300000	35000	Diesel	Individual	Automatic	Third Owner	6	Audi
1462	Audi A8 L 3.0 TDI quattro	1250000	47000	Diesel	Dealer	Automatic	Second Owner	12	Audi
1479	Audi A4 35 TDI Premium Plus	3256000	17000	Diesel	Dealer	Automatic	First Owner	2	Audi
1705	Audi Q5 2.0 TDI	3500000	35000	Diesel	Individual	Automatic	First Owner	6	Audi
1835	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
1847	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
2238	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
2250	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
2257	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
2269	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
2295	Audi Q5 3.0 TDI Quattro Technology	3899000	22000	Diesel	Dealer	Automatic	First Owner	3	Audi
2323	Audi A4 30 TFSI Technology	3100000	22000	Petrol	Individual	Automatic	First Owner	3	Audi
2572	Audi A6 2.0 TDI Premium Plus	1470000	34000	Diesel	Dealer	Automatic	Second Owner	7	Audi
2574	Audi A8 4.2 TDI	2800000	49000	Diesel	Dealer	Automatic	First Owner	8	Audi
2578	Audi A4 2.0 TDI 177 Bhp Premium Plus	1150000	53000	Diesel	Dealer	Automatic	First Owner	8	Audi
2685	Audi Q5 2.0 TFSI Quattro	1100000	110000	Petrol	Individual	Automatic	First Owner	11	Audi
2738	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
2750	Audi A6 2.0 TDI Premium Plus	1300000	58500	Diesel	Dealer	Automatic	First Owner	8	Audi
2813	Audi Q3 2.0 TDI Quattro Premium Plus	1150000	110000	Diesel	Individual	Automatic	Second Owner	7	Audi
3082	Audi A6 2.7 TDI	850000	46000	Diesel	Individual	Automatic	First Owner	11	Audi
3094	Audi A4 2.0 TDI	1295000	58000	Diesel	Dealer	Automatic	First Owner	10	Audi
3458	Audi A4 1.8 TFSI	1200000	60000	Petrol	Individual	Automatic	Third Owner	9	Audi
3783	Audi A6 2.8 FSI	650000	70000	Petrol	Individual	Automatic	Third Owner	13	Audi
3842	Audi A4 3.0 TDI Quattro	1580000	86000	Diesel	Dealer	Automatic	First Owner	8	Audi
3843	Audi Q3 2.0 TDI Quattro Premium Plus	1750000	127643	Diesel	Dealer	Automatic	First Owner	6	Audi
3848	Audi A6 2.0 TDI Design Edition	1750000	102354	Diesel	Dealer	Automatic	First Owner	7	Audi
3851	Audi Q3 35 TDI Quattro Technology	2575000	36000	Diesel	Dealer	Automatic	First Owner	4	Audi
3854	Audi Q5 2.0 TFSI Quattro Premium Plus	1850000	62237	Petrol	Dealer	Automatic	First Owner	7	Audi
3872	Audi RS7 2015-2019 Sportback Performance	8900000	13000	Petrol	Dealer	Automatic	First Owner	5	Audi
3873	Audi Q5 3.0 TDI Quattro Technology	3200000	30000	Diesel	Dealer	Automatic	First Owner	6	Audi
4163	Audi Q3 2.0 TDI Quattro Premium Plus	1400000	118000	Diesel	Individual	Automatic	Second Owner	9	Audi
4304	Audi Q5 3.0 TDI Quattro Technology	3899000	22000	Diesel	Dealer	Automatic	First Owner	3	Audi

	selling_price	km_driven	Age
brand
Audi	1.931633e+06	64459.716667	7.383333
Jaguar	2.069166e+06	52454.333333	8.833333
Volvo	2.556250e+06	86748.000000	5.750000
Mercedes-Benz	2.776657e+06	42946.571429	7.771429
BMW	2.945385e+06	44883.179487	5.666667
Land	3.609800e+06	87600.000000	6.200000

	selling_price	km_driven	Age
brand
Daewoo	6.000000e+04	50000.000000	19.000000
OpelCorsa	8.850000e+04	86500.000000	18.000000
Ambassador	1.800000e+05	67500.000000	15.000000
Chevrolet	2.367271e+05	72217.218085	8.909574
Fiat	2.834324e+05	79822.648649	8.945946
Tata	2.840834e+05	75933.714681	8.614958
Datsun	2.970269e+05	29564.351351	4.486486
Maruti	3.424163e+05	63264.387500	8.491406
Force	3.460000e+05	37516.000000	7.000000
Renault	4.193767e+05	47421.287671	5.589041
Hyundai	4.199403e+05	55767.695493	7.706456
Nissan	4.499375e+05	68684.515625	7.031250
Volkswagen	4.710373e+05	74776.112150	7.672897
Skoda	4.900147e+05	82591.397059	8.955882
Honda	5.381468e+05	57080.805556	7.146825
Ford	5.712731e+05	65041.399160	7.138655
Mahindra	5.877095e+05	83098.309589	7.608219
Mitsubishi	8.400000e+05	141311.666667	10.166667
Toyota	9.243592e+05	100396.014563	7.917476
Kia	1.300000e+06	10000.000000	2.000000
Isuzu	1.500000e+06	40000.000000	3.000000
Jeep	1.530000e+06	27346.000000	3.000000
MG	1.842500e+06	16000.000000	2.000000